USE [Clinic]
GO
/****** Object:  StoredProcedure [dbo].[up_PatientsGetNames]    Script Date: 01/28/2008 14:24:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[up_DoctorsGetNames]

AS
BEGIN
SET NOCOUNT ON;

	SELECT DoctorID, ([FirstName] + ' ' + LastName) AS DoctorName
	FROM Doctors
	
END


/****** Object:  StoredProcedure [dbo].[up_PatientsUpdate]    Script Date: 12/28/2007 19:54:57 ******/
SET ANSI_NULLS ON